SyUserLog

Logical Entity Name | SyUserLog
Default Table Name | SyUserLog
Physical Only | NO
Owner | dbo
Definition |
Note |

SyUserLog Columns

ColumnName | Domain | Datatype | NULL | Definition
SyUserLogID |  | int | NO |
SyStaffID |  | int | YES |
SignInCampus |  | int | YES |
Workstation |  | varchar(50) | YES |
SignInDateTime |  | datetime | YES |
SignOutDateTime |  | datetime | YES |
dateAdded |  | datetime | YES |
datelstmod |  | datetime | YES |
ts |  | timestamp | NO |

SyUserLog Primary and Unique Keys

Key Name | Key Type | Keys
SyUserLog_SyUserLogID_U_C_IDX | PrimaryKey | SyUserLogID

SyUserLog Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

SyUserLog Check Constraints

Check Constraint Name | CheckConstraint

SyUserLog Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SyUserLog Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyUserLog | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyUserLog | NO |  |  |

SyUserLog Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyUserLog Data Movement Rules

Name | Type | Rule Text/Value